TABLE OF CONTENTS
DECLARATION I
APPROVAL II
DEDICATION Ill
ACKNOWLEDGEMENT IV
LIST OF TABLES VIII
LIST OF FIGURES IX
ABBREVIATIONS X
ABSTRACT XI
CHAPTER ONE 1
INTRODUCTION 1
1.1 INTRODUCTION 1
1.2 BACKGROUND OF THE STUDY
1.3 SCOPE OF THE STUDY 2
1.3.1 Geographical scope 2
1.3.2 Scope ofthe System 2
1.4 STATEMENT OF TilE PROBLEM 2
1.5 OBJECTIVES 3
1.5. 1 Main Objectives 3
1.5.2 Specific Objectives 3
1.7 CONCEPTUAL FRAMEWORK 4
1.8 SIGNIFICANCE OFTI-IE STUDY 4
CHAPTER TWO 6
LITERATURE REVIEW 6
2.1 INTRODUCTION 6
2.2 KNOWLEI)GE BASED SYSTEMS 6
2.3 DATABASE AND DATABASE SYSTEM 6
2.4 DATABASE MANAGEMENT SYSTE~ 8
2.5 BENEFITS OF A DATABASE AND DATABASE MANAGEMENT SYSTEM 8
V
2.6 FUNCTIONS OF DATABASE AND DATABASE MANAGEMENT SYSTEM 9
2.7 iNFORMATION SYSTE~ io
2.8 MANAGEMENT INFORMATION SYSTEM
2.9 CoNCLUSION 11
CHAPTER THREE 12
METHODOLOGY 12
3.1 INTRODUCTION 12
3.2 ORGANIzATION UNIT TO BE STUDIED 12
3.3 RISK ASSESSMENT 12
3.5 SYSTEMS DEVELOPMENT METHODOLOGY 13
3.5.1 Requirements gathering and Analysis 13
3.5.2 System & Software Design 13
3.5.3 Implementation and unit testing 14
3.5.4 Integration & System Testing 14
3.5.5 Operations & Maintenance 14
3.6 CONCLUSION 14
CHAPTER FOUR 15
SYSTEMS ANALYSIS AND DESIGN 15
4.0 INTRODUCTION 15
4.1 SYSTEM ANALYSIS I5
4.1.1 Procedure ofthe Study 15
4.1.2 Target Population 16
4.1.3 Sample Selection 16
4.1.4 Data collection Tools 17
4.1.5 Analysis froni the Study 17
4.1.5.1 Introduction I 7
4.1.5.2 Population of the Respondents 18
4.1.5.3 Analysis of the Respondents Age and Gende 18
4.1.5.4 Level of the respondents 19
4.1.5.5 Response on loan taking Procedure’ 19
4.1.5.6 Response on whether respondents had a Computerized Loan System 20
4.1.5.7 Response on the Efficiency of the System 21
4.1.5.8 Response on whether the banks are in Partnership with CRB 21
4.1.5.9 Response on whether the CRB is going to improve the loan acquisition procedure 22
4.1.6 Feasibility Analysis 22
4.1. 7 System Specifications 23
4.1.7.1 Systems Requirements 23
4.1.7.2 Functional Requirements’ 23
Vi
4.1.7.3 Non-Functional Requirements .24
4.1.8 Hardware and Software Requirements 25
4.2 SYSTEMS DESIGN 26
4.2.1 Context level Diagram of the new system 26
4.2.2 Class Diagram representing the nei~ system 27
4.2.1 Sequence Diagram 29
4.2.4 Database Design 30
43.5 Structure oft/ic Information Systemfor C’ompuscan Credit Refi~rence Bureau 33
4.3 CoNcLusioN 34
CHAPTER FIVE 35
SYSTEM IMPLEMENTATION AND UNIT TESTING 35
5.0 INTRODUCTION 35
5.1 SYSTEM IMPLEMENTATION 35
5.2 SYSTEM CODING 35
5.3 TESTING 36
5.3.1 Unit Testing 36
5.3.2 Integration testing 36
5.3.3 System Testing 36
5.4 USER INTERFACES 37
5.5 SAMPuE DATA INPUT 47
5.6 SAMI’LE DATA OuTPUT 48
5.7 USER TRAINING 53
5.6 CONCLUSION 53
CHAPTER SIX 54
RECOMMENDATIONS, DISCUSSIONS AND CONCLUSIONS 54
6.0 INTRODUCTION 54
6.1 RECOMMENDATION 54
6.2 DISCUSSION 55
6.3 CONCLUSIONS 56
BIBLIOGRAPHY 57
APPENDICES 58
APPENDIX A: TIME FRAME 58
APPENDIX B: SAMPLE CODES 59
APPENDIX C: MYSQL DATABASE CODES 64
APPENDIX D: QUESTIONNAIRE 68
ABSTRACT The process of loan acquisition in Uganda has been very tedious with long lists of forms to be filled, checks to pass, vast security requirements and very high interest rates involved. Compuscan Credit Reference Bureau (U) ltd is a south African~based private company that was licensed in 2006 by Bank of Uganda to collect financial information about individual borrowers and companies. This information is then analyzed and presented to banks and other legal lending institutions for them to make decisions depending on credit ~‘orthjness of the borrower. This research aims at creating an information system that will be able to collect, analyze and interpret data from borrowers and avail it to the participating banks for them to make decisions on whether to lend or not. Registered members will be issued with a financial card which will contain all their details on credit worthiness. This will be taken as a single requirement for loan acquisition in Uganda and shall in the long run reduce the interest rates on loans.
